/********************************************************************
  Copyright by PCI, 2002-10-08
  File Name: db_ppm_price_plan_bill.cxx
  Created Date: 2002-10-08 
  Author: Machine
  Version: 1.0 
  Last Version Date: 
  Version Date:
*******************************************************************/
/********************************************************************
  Copyright by PCI, 2002-10-08
  Class Name: CTable_PPM_PRICE_PLAN_BILL
  Created Date: 2002-10-08 
  Author: Machine
  Defined File: db_ppm_price_plan_bill.hxx
  Last Version Date: 
  Version Date:
*******************************************************************/
#include "table_ppm.h"

CTable_PPM_PRICE_PLAN_BILL::CTable_PPM_PRICE_PLAN_BILL( )
 :NPCRecordSet( )
{
  setTableName( "PPM_PRICE_PLAN_BILL" );
  prepareTable();
  prepareQuery();
 
  ID.setField( "ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( ID );
  makeKeyItem( ID ); 
  NAME.setField( "NAME", DATA_CHAR, 512, 0 );
  makeTableItem( NAME );
  CODE.setField( "CODE", DATA_CHAR, 200, 0 );
  makeTableItem( CODE );
  APP_ID.setField( "APP_ID", DATA_CHAR, 20, 0 );
  makeTableItem( APP_ID );
  APP_STATE.setField( "APP_STATE", DATA_CHAR, 20, 0 );
  makeTableItem( APP_STATE );
  IS_OPT_PKG.setField( "IS_OPT_PKG", DATA_CHAR, 20, 0 );
  makeTableItem( IS_OPT_PKG );
  ADD_PKG_CODE.setField( "ADD_PKG_CODE", DATA_CHAR, 100, 0 );
  makeTableItem( ADD_PKG_CODE );
  OPT_PKG_CODE.setField( "OPT_PKG_CODE", DATA_CHAR, 100, 0 );
  makeTableItem( OPT_PKG_CODE );
  TYPE.setField( "TYPE", DATA_CHAR, 50, 0 );
  makeTableItem( TYPE );
  USER_ITEM_NAME.setField( "USER_ITEM_NAME", DATA_CHAR, 512, 0 );
  makeTableItem( USER_ITEM_NAME );
  ACC_ITEM_NAME.setField( "ACC_ITEM_NAME", DATA_CHAR, 512, 0 );
  makeTableItem( ACC_ITEM_NAME );
}


CTable_PPM_PRICE_PLAN_BILL::CTable_PPM_PRICE_PLAN_BILL( NPConnection& pcldb )
 :NPCRecordSet( pcldb )
{
  setTableName( "PPM_PRICE_PLAN_BILL" );
  prepareTable();
  prepareQuery();
 
  ID.setField( "ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( ID );
  makeKeyItem( ID ); 
  NAME.setField( "NAME", DATA_CHAR, 512, 0 );
  makeTableItem( NAME );
  CODE.setField( "CODE", DATA_CHAR, 200, 0 );
  makeTableItem( CODE );
  APP_ID.setField( "APP_ID", DATA_CHAR, 20, 0 );
  makeTableItem( APP_ID );
  APP_STATE.setField( "APP_STATE", DATA_CHAR, 20, 0 );
  makeTableItem( APP_STATE );
  IS_OPT_PKG.setField( "IS_OPT_PKG", DATA_CHAR, 20, 0 );
  makeTableItem( IS_OPT_PKG );
  ADD_PKG_CODE.setField( "ADD_PKG_CODE", DATA_CHAR, 100, 0 );
  makeTableItem( ADD_PKG_CODE );
  OPT_PKG_CODE.setField( "OPT_PKG_CODE", DATA_CHAR, 100, 0 );
  makeTableItem( OPT_PKG_CODE );
  TYPE.setField( "TYPE", DATA_CHAR, 50, 0 );
  makeTableItem( TYPE );
  USER_ITEM_NAME.setField( "USER_ITEM_NAME", DATA_CHAR, 512, 0 );
  makeTableItem( USER_ITEM_NAME );
  ACC_ITEM_NAME.setField( "ACC_ITEM_NAME", DATA_CHAR, 512, 0 );
  makeTableItem( ACC_ITEM_NAME );
}

CTable_PPM_PRICE_PLAN_BILL::~CTable_PPM_PRICE_PLAN_BILL( )
{
    close();
}

